import matplotlib.pyplot as plt
import pandas as pd
df=pd.read_excel('图书各地区销售表.xlsx',index_col=0)
data=df.agg('sum')
plt.rcParams['font.sans-serif']='SimHei'
plt.title('各地区图书销售额饼状图')
plt.show()